{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 第一题（数据导入）"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1.1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\study\\anaconda\\Lib\\site-packages\\openpyxl\\styles\\stylesheet.py:237: UserWarning: Workbook contains no default style, apply openpyxl's default\n",
      "  warn(\"Workbook contains no default style, apply openpyxl's default\")\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>学校</th>\n",
       "      <th>院系</th>\n",
       "      <th>专业</th>\n",
       "      <th>行政班级</th>\n",
       "      <th>出勤（次）</th>\n",
       "      <th>缺勤（次）</th>\n",
       "      <th>已过期（次）</th>\n",
       "      <th>早退（次）</th>\n",
       "      <th>迟到（次）</th>\n",
       "      <th>病假（次）</th>\n",
       "      <th>事假（次）</th>\n",
       "      <th>公假（次）</th>\n",
       "      <th>签到率(%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>朱文清</td>\n",
       "      <td>2018126105</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>78.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>刘宸言</td>\n",
       "      <td>20221310205</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>苏梓珊</td>\n",
       "      <td>20221310220</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310101</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>郑佳荣</td>\n",
       "      <td>20231310102</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>叶亦坤</td>\n",
       "      <td>20231310103</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>金婉欣</td>\n",
       "      <td>20231310104</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>陈嘉诚</td>\n",
       "      <td>20231310105</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>张鹏泉</td>\n",
       "      <td>20231310106</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>卢述桔</td>\n",
       "      <td>20231310107</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>陆湘雄</td>\n",
       "      <td>20231310108</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>施广旭</td>\n",
       "      <td>20231310109</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>葛榛</td>\n",
       "      <td>20231310110</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>林志杰</td>\n",
       "      <td>20231310111</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>徐伟涛</td>\n",
       "      <td>20231310112</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>姚鸿斌</td>\n",
       "      <td>20231310113</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>71.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>林佳怡</td>\n",
       "      <td>20231310114</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>李冬怡</td>\n",
       "      <td>20231310115</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>陈龙</td>\n",
       "      <td>20231310116</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>陈佳伟</td>\n",
       "      <td>20231310117</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>57.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>林琦凤</td>\n",
       "      <td>20231310118</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>倪旭昶</td>\n",
       "      <td>20231310119</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>林欣</td>\n",
       "      <td>20231310120</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>庄杰雄</td>\n",
       "      <td>20231310121</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>李凌翔</td>\n",
       "      <td>20231310122</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>张润泽</td>\n",
       "      <td>20231310123</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>陈梦雪</td>\n",
       "      <td>20231310124</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>林凯怡</td>\n",
       "      <td>20231310125</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>林坤宇</td>\n",
       "      <td>20231310127</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>78.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>傅英姿</td>\n",
       "      <td>20231310128</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>王庆南</td>\n",
       "      <td>20231310129</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>吴俊鎔</td>\n",
       "      <td>20231310130</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>朱淇蔓</td>\n",
       "      <td>20231310131</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>陈皓晗</td>\n",
       "      <td>20231310132</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>罗瀛</td>\n",
       "      <td>20231310133</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>71.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>侯绍平</td>\n",
       "      <td>20231310134</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>余姗珊</td>\n",
       "      <td>20231310135</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>赵静怡</td>\n",
       "      <td>20231310136</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>陈烨坤</td>\n",
       "      <td>20231310137</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>马海悦</td>\n",
       "      <td>20231310138</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>吴岩</td>\n",
       "      <td>20231310140</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>马均宇</td>\n",
       "      <td>20231310141</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>刘硕</td>\n",
       "      <td>20231310142</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>陈治燃</td>\n",
       "      <td>20231310143</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>唐塬智</td>\n",
       "      <td>20231310144</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>朱德伟</td>\n",
       "      <td>20231310145</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>林楠</td>\n",
       "      <td>20231310146</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>翁赵熠</td>\n",
       "      <td>20231310147</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>向志诚</td>\n",
       "      <td>20231310148</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>胡星婷</td>\n",
       "      <td>20231310149</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>文涛</td>\n",
       "      <td>20231310150</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>伍际硕</td>\n",
       "      <td>20231310151</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>曹梓扬</td>\n",
       "      <td>20231310152</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>71.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>周昊</td>\n",
       "      <td>20231310153</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>71.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>林福滨</td>\n",
       "      <td>20231310154</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>71.43</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     姓名        学号/工号          学校   院系     专业    行政班级  出勤（次）  缺勤（次）  已过期（次）  \\\n",
       "0   朱文清   2018126105  厦门兴才职业技术学院  工学院  大数据技术  数据2311     11      3       0   \n",
       "1   刘宸言  20221310205  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "2   苏梓珊  20221310220  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      2       0   \n",
       "3    陈昊  20231310101  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "4   郑佳荣  20231310102  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "5   叶亦坤  20231310103  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "6   金婉欣  20231310104  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "7   陈嘉诚  20231310105  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "8   张鹏泉  20231310106  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "9   卢述桔  20231310107  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      0       0   \n",
       "10  陆湘雄  20231310108  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "11  施广旭  20231310109  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "12   葛榛  20231310110  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      0       0   \n",
       "13  林志杰  20231310111  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "14  徐伟涛  20231310112  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "15  姚鸿斌  20231310113  厦门兴才职业技术学院  工学院  大数据技术  数据2311     10      4       0   \n",
       "16  林佳怡  20231310114  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      0       0   \n",
       "17  李冬怡  20231310115  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "18   陈龙  20231310116  厦门兴才职业技术学院  工学院  大数据技术  数据2311      9      5       0   \n",
       "19  陈佳伟  20231310117  厦门兴才职业技术学院  工学院  大数据技术  数据2311      8      6       0   \n",
       "20  林琦凤  20231310118  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "21  倪旭昶  20231310119  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "22   林欣  20231310120  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "23  庄杰雄  20231310121  厦门兴才职业技术学院  工学院  大数据技术  数据2311      9      5       0   \n",
       "24  李凌翔  20231310122  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      2       0   \n",
       "25  张润泽  20231310123  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "26  陈梦雪  20231310124  厦门兴才职业技术学院  工学院  大数据技术  数据2311      6      8       0   \n",
       "27  林凯怡  20231310125  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      1       0   \n",
       "28  林坤宇  20231310127  厦门兴才职业技术学院  工学院  大数据技术  数据2311     11      2       0   \n",
       "29  傅英姿  20231310128  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      0       0   \n",
       "30  王庆南  20231310129  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "31  吴俊鎔  20231310130  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "32  朱淇蔓  20231310131  厦门兴才职业技术学院  工学院  大数据技术  数据2311      7      5       0   \n",
       "33  陈皓晗  20231310132  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "34   罗瀛  20231310133  厦门兴才职业技术学院  工学院  大数据技术  数据2311     10      1       0   \n",
       "35  侯绍平  20231310134  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "36  余姗珊  20231310135  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "37  赵静怡  20231310136  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      0       0   \n",
       "38  陈烨坤  20231310137  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      2       0   \n",
       "39  马海悦  20231310138  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      0       0   \n",
       "40   吴岩  20231310140  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      0       0   \n",
       "41  马均宇  20231310141  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "42   刘硕  20231310142  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "43  陈治燃  20231310143  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "44  唐塬智  20231310144  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "45  朱德伟  20231310145  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "46   林楠  20231310146  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "47  翁赵熠  20231310147  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "48  向志诚  20231310148  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "49  胡星婷  20231310149  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      2       0   \n",
       "50   文涛  20231310150  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "51  伍际硕  20231310151  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      2       0   \n",
       "52  曹梓扬  20231310152  厦门兴才职业技术学院  工学院  大数据技术  数据2311     10      4       0   \n",
       "53   周昊  20231310153  厦门兴才职业技术学院  工学院  大数据技术  数据2311     10      1       0   \n",
       "54  林福滨  20231310154  厦门兴才职业技术学院  工学院  大数据技术  数据2311     10      2       0   \n",
       "\n",
       "    早退（次）  迟到（次）  病假（次）  事假（次）  公假（次）  签到率(%)  \n",
       "0       0      0      0      0      0   78.57  \n",
       "1       0      0      0      0      0   92.86  \n",
       "2       0      0      0      0      0   85.71  \n",
       "3       0      0      0      0      0  100.00  \n",
       "4       0      0      0      0      0  100.00  \n",
       "5       0      0      0      0      0  100.00  \n",
       "6       0      0      0      0      0  100.00  \n",
       "7       0      0      0      0      0  100.00  \n",
       "8       0      0      0      0      0  100.00  \n",
       "9       0      0      0      1      0   92.86  \n",
       "10      0      0      0      0      0   92.86  \n",
       "11      0      0      0      0      0  100.00  \n",
       "12      0      0      0      1      0   92.86  \n",
       "13      0      0      0      0      0  100.00  \n",
       "14      0      0      0      0      0  100.00  \n",
       "15      0      0      0      0      0   71.43  \n",
       "16      0      0      0      1      0   92.86  \n",
       "17      0      0      0      0      0   92.86  \n",
       "18      0      0      0      0      0   64.29  \n",
       "19      0      0      0      0      0   57.14  \n",
       "20      0      0      0      0      0  100.00  \n",
       "21      0      0      0      0      0   92.86  \n",
       "22      0      0      0      0      0  100.00  \n",
       "23      0      0      0      0      0   64.29  \n",
       "24      0      0      0      0      0   85.71  \n",
       "25      0      0      0      0      0   92.86  \n",
       "26      0      0      0      0      0   42.86  \n",
       "27      0      0      0      0      1   85.71  \n",
       "28      0      0      0      1      0   78.57  \n",
       "29      0      0      0      0      2   85.71  \n",
       "30      0      0      0      0      0  100.00  \n",
       "31      0      0      0      0      0   92.86  \n",
       "32      0      0      0      2      0   50.00  \n",
       "33      0      0      0      0      0   92.86  \n",
       "34      0      0      0      3      0   71.43  \n",
       "35      0      0      0      0      0   92.86  \n",
       "36      0      0      0      0      0  100.00  \n",
       "37      0      0      0      0      1   92.86  \n",
       "38      0      0      0      0      0   85.71  \n",
       "39      0      0      0      2      0   85.71  \n",
       "40      0      0      1      0      0   92.86  \n",
       "41      0      0      0      0      0  100.00  \n",
       "42      0      0      0      0      0   92.86  \n",
       "43      0      0      0      0      0  100.00  \n",
       "44      0      0      0      0      0  100.00  \n",
       "45      0      0      0      0      0  100.00  \n",
       "46      0      0      0      0      0   92.86  \n",
       "47      0      0      0      0      0   92.86  \n",
       "48      0      0      0      0      0   92.86  \n",
       "49      0      0      0      0      0   85.71  \n",
       "50      0      0      0      0      0   92.86  \n",
       "51      0      0      0      0      0   85.71  \n",
       "52      0      0      0      0      0   71.43  \n",
       "53      0      1      0      2      0   71.43  \n",
       "54      0      1      0      1      0   71.43  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "qd2311 = pd.read_excel('数据2311学生签到统计详情.xlsx', skiprows = 5)\n",
    "qd2311"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\study\\anaconda\\Lib\\site-packages\\openpyxl\\styles\\stylesheet.py:237: UserWarning: Workbook contains no default style, apply openpyxl's default\n",
      "  warn(\"Workbook contains no default style, apply openpyxl's default\")\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>学校</th>\n",
       "      <th>院系</th>\n",
       "      <th>专业</th>\n",
       "      <th>行政班级</th>\n",
       "      <th>出勤（次）</th>\n",
       "      <th>缺勤（次）</th>\n",
       "      <th>已过期（次）</th>\n",
       "      <th>早退（次）</th>\n",
       "      <th>迟到（次）</th>\n",
       "      <th>病假（次）</th>\n",
       "      <th>事假（次）</th>\n",
       "      <th>公假（次）</th>\n",
       "      <th>签到率(%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>高存平</td>\n",
       "      <td>20221310228</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>傅景华</td>\n",
       "      <td>20231310201</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>许仕凡</td>\n",
       "      <td>20231310202</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>邱粤汉</td>\n",
       "      <td>20231310203</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>卢作培</td>\n",
       "      <td>20231310204</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>吴泰成</td>\n",
       "      <td>20231310205</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>陈双俊</td>\n",
       "      <td>20231310206</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>叶育贤</td>\n",
       "      <td>20231310207</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>叶有鑫</td>\n",
       "      <td>20231310208</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>苏增宏</td>\n",
       "      <td>20231310209</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>93.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>黄锦弘</td>\n",
       "      <td>20231310210</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>钟淑川</td>\n",
       "      <td>20231310211</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>林金</td>\n",
       "      <td>20231310212</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>吴丽媛</td>\n",
       "      <td>20231310213</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>王正元</td>\n",
       "      <td>20231310214</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>陈佳阳</td>\n",
       "      <td>20231310215</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>苏源城</td>\n",
       "      <td>20231310216</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>林涛</td>\n",
       "      <td>20231310217</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>李家烨</td>\n",
       "      <td>20231310218</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>46.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>吴思钰</td>\n",
       "      <td>20231310219</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>翁诚峰</td>\n",
       "      <td>20231310220</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>詹方煜</td>\n",
       "      <td>20231310221</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>林传江</td>\n",
       "      <td>20231310222</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>张志鹏</td>\n",
       "      <td>20231310223</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>任志洋</td>\n",
       "      <td>20231310224</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>46.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>王标凌</td>\n",
       "      <td>20231310225</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>陈瑞枫</td>\n",
       "      <td>20231310226</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>张斌彬</td>\n",
       "      <td>20231310227</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>王炉垚</td>\n",
       "      <td>20231310229</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>林元曦</td>\n",
       "      <td>20231310230</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>车炯</td>\n",
       "      <td>20231310231</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>郭可怡</td>\n",
       "      <td>20231310232</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>86.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>钱孟杰</td>\n",
       "      <td>20231310233</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>鲁家灿</td>\n",
       "      <td>20231310234</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>颜悦婷</td>\n",
       "      <td>20231310235</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>陈隆嘉</td>\n",
       "      <td>20231310236</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>陈灿贤</td>\n",
       "      <td>20231310237</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>曹俊豪</td>\n",
       "      <td>20231310239</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>陈慧真</td>\n",
       "      <td>20231310240</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>王伟凡</td>\n",
       "      <td>20231310241</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>陈渝儿</td>\n",
       "      <td>20231310242</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>陈国洪</td>\n",
       "      <td>20231310243</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>肖艳妮</td>\n",
       "      <td>20231310244</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>郭佳琪</td>\n",
       "      <td>20231310245</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>93.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>黄朱晴</td>\n",
       "      <td>20231310246</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>66.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>饶煌彪</td>\n",
       "      <td>20231310247</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>80.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>钟雨渲</td>\n",
       "      <td>20231310248</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>林敬耀</td>\n",
       "      <td>20231310249</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>贾兆</td>\n",
       "      <td>20231310250</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>46.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310251</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>陈欣蕾</td>\n",
       "      <td>20231790208</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     姓名        学号/工号          学校   院系     专业    行政班级  出勤（次）  缺勤（次）  已过期（次）  \\\n",
       "0   高存平  20221310228  厦门兴才职业技术学院  工学院  大数据技术  数据2312     10      5       0   \n",
       "1   傅景华  20231310201  厦门兴才职业技术学院  工学院  大数据技术  数据2312     12      2       0   \n",
       "2   许仕凡  20231310202  厦门兴才职业技术学院  工学院  大数据技术  数据2312      1     12       0   \n",
       "3   邱粤汉  20231310203  厦门兴才职业技术学院  工学院  大数据技术  数据2312      8      6       0   \n",
       "4   卢作培  20231310204  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "5   吴泰成  20231310205  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "6   陈双俊  20231310206  厦门兴才职业技术学院  工学院  大数据技术  数据2312     13      0       0   \n",
       "7   叶育贤  20231310207  厦门兴才职业技术学院  工学院  大数据技术  数据2312     11      2       0   \n",
       "8   叶有鑫  20231310208  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "9   苏增宏  20231310209  厦门兴才职业技术学院  工学院  大数据技术  数据2312     14      0       0   \n",
       "10  黄锦弘  20231310210  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "11  钟淑川  20231310211  厦门兴才职业技术学院  工学院  大数据技术  数据2312     11      3       0   \n",
       "12   林金  20231310212  厦门兴才职业技术学院  工学院  大数据技术  数据2312      5      3       0   \n",
       "13  吴丽媛  20231310213  厦门兴才职业技术学院  工学院  大数据技术  数据2312     12      1       0   \n",
       "14  王正元  20231310214  厦门兴才职业技术学院  工学院  大数据技术  数据2312     11      1       0   \n",
       "15  陈佳阳  20231310215  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "16  苏源城  20231310216  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "17   林涛  20231310217  厦门兴才职业技术学院  工学院  大数据技术  数据2312      0     15       0   \n",
       "18  李家烨  20231310218  厦门兴才职业技术学院  工学院  大数据技术  数据2312      7      2       0   \n",
       "19  吴思钰  20231310219  厦门兴才职业技术学院  工学院  大数据技术  数据2312     10      4       0   \n",
       "20  翁诚峰  20231310220  厦门兴才职业技术学院  工学院  大数据技术  数据2312     11      3       0   \n",
       "21  詹方煜  20231310221  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "22  林传江  20231310222  厦门兴才职业技术学院  工学院  大数据技术  数据2312      2     10       0   \n",
       "23  张志鹏  20231310223  厦门兴才职业技术学院  工学院  大数据技术  数据2312      6      6       0   \n",
       "24  任志洋  20231310224  厦门兴才职业技术学院  工学院  大数据技术  数据2312      7      4       0   \n",
       "25  王标凌  20231310225  厦门兴才职业技术学院  工学院  大数据技术  数据2312     11      0       0   \n",
       "26  陈瑞枫  20231310226  厦门兴才职业技术学院  工学院  大数据技术  数据2312      6      2       0   \n",
       "27  张斌彬  20231310227  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "28  王炉垚  20231310229  厦门兴才职业技术学院  工学院  大数据技术  数据2312      4      7       0   \n",
       "29  林元曦  20231310230  厦门兴才职业技术学院  工学院  大数据技术  数据2312      8      1       0   \n",
       "30   车炯  20231310231  厦门兴才职业技术学院  工学院  大数据技术  数据2312      3     11       0   \n",
       "31  郭可怡  20231310232  厦门兴才职业技术学院  工学院  大数据技术  数据2312     13      0       0   \n",
       "32  钱孟杰  20231310233  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "33  鲁家灿  20231310234  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "34  颜悦婷  20231310235  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "35  陈隆嘉  20231310236  厦门兴才职业技术学院  工学院  大数据技术  数据2312      1     12       0   \n",
       "36  陈灿贤  20231310237  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "37  曹俊豪  20231310239  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "38  陈慧真  20231310240  厦门兴才职业技术学院  工学院  大数据技术  数据2312     11      2       0   \n",
       "39  王伟凡  20231310241  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "40  陈渝儿  20231310242  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "41  陈国洪  20231310243  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "42  肖艳妮  20231310244  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "43  郭佳琪  20231310245  厦门兴才职业技术学院  工学院  大数据技术  数据2312     14      0       0   \n",
       "44  黄朱晴  20231310246  厦门兴才职业技术学院  工学院  大数据技术  数据2312     10      3       0   \n",
       "45  饶煌彪  20231310247  厦门兴才职业技术学院  工学院  大数据技术  数据2312     12      1       0   \n",
       "46  钟雨渲  20231310248  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "47  林敬耀  20231310249  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "48   贾兆  20231310250  厦门兴才职业技术学院  工学院  大数据技术  数据2312      7      5       0   \n",
       "49   陈昊  20231310251  厦门兴才职业技术学院  工学院  大数据技术  数据2312      1     11       0   \n",
       "50  陈欣蕾  20231790208  厦门兴才职业技术学院  工学院  大数据技术  数据2312      1     14       0   \n",
       "\n",
       "    早退（次）  迟到（次）  病假（次）  事假（次）  公假（次）  签到率(%)  \n",
       "0       0      0      0      0      0   66.67  \n",
       "1       0      1      0      0      0   80.00  \n",
       "2       0      1      0      1      0    6.67  \n",
       "3       0      1      0      0      0   53.33  \n",
       "4       0      0      0      0      0  100.00  \n",
       "5       0      0      0      0      0  100.00  \n",
       "6       0      2      0      0      0   86.67  \n",
       "7       0      1      0      1      0   73.33  \n",
       "8       0      0      0      0      0  100.00  \n",
       "9       0      1      0      0      0   93.33  \n",
       "10      0      0      0      0      0  100.00  \n",
       "11      0      1      0      0      0   73.33  \n",
       "12      0      7      0      0      0   33.33  \n",
       "13      0      1      0      1      0   80.00  \n",
       "14      0      3      0      0      0   73.33  \n",
       "15      0      0      0      0      0  100.00  \n",
       "16      0      0      0      0      0  100.00  \n",
       "17      0      0      0      0      0    0.00  \n",
       "18      0      6      0      0      0   46.67  \n",
       "19      0      1      0      0      0   66.67  \n",
       "20      0      0      0      1      0   73.33  \n",
       "21      0      0      0      0      0  100.00  \n",
       "22      0      3      0      0      0   13.33  \n",
       "23      0      3      0      0      0   40.00  \n",
       "24      0      4      0      0      0   46.67  \n",
       "25      0      2      0      2      0   73.33  \n",
       "26      0      7      0      0      0   40.00  \n",
       "27      0      0      0      0      0  100.00  \n",
       "28      0      4      0      0      0   26.67  \n",
       "29      0      6      0      0      0   53.33  \n",
       "30      0      0      0      1      0   20.00  \n",
       "31      0      0      0      2      0   86.67  \n",
       "32      0      0      0      0      0  100.00  \n",
       "33      0      0      0      0      0  100.00  \n",
       "34      0      0      0      0      0  100.00  \n",
       "35      0      2      0      0      0    6.67  \n",
       "36      0      0      0      0      0  100.00  \n",
       "37      0      0      0      0      0  100.00  \n",
       "38      0      1      0      1      0   73.33  \n",
       "39      0      0      0      0      0  100.00  \n",
       "40      0      0      0      0      0  100.00  \n",
       "41      0      0      0      0      0  100.00  \n",
       "42      0      0      0      0      0  100.00  \n",
       "43      0      0      0      0      1   93.33  \n",
       "44      0      0      0      2      0   66.67  \n",
       "45      0      1      0      0      1   80.00  \n",
       "46      0      0      0      0      0  100.00  \n",
       "47      0      0      0      0      0  100.00  \n",
       "48      0      2      0      1      0   46.67  \n",
       "49      0      2      0      1      0    6.67  \n",
       "50      0      0      0      0      0    6.67  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "qd2312 = pd.read_excel('数据2312学生签到统计详情.xlsx',skiprows = 5)\n",
    "qd2312"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\study\\anaconda\\Lib\\site-packages\\openpyxl\\styles\\stylesheet.py:237: UserWarning: Workbook contains no default style, apply openpyxl's default\n",
      "  warn(\"Workbook contains no default style, apply openpyxl's default\")\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>院系</th>\n",
       "      <th>专业</th>\n",
       "      <th>班级</th>\n",
       "      <th>提交数</th>\n",
       "      <th>被批阅</th>\n",
       "      <th>最高分</th>\n",
       "      <th>最低分</th>\n",
       "      <th>平均分(计算已批阅)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>林福滨</td>\n",
       "      <td>20231310154</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>周昊</td>\n",
       "      <td>20231310153</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>曹梓扬</td>\n",
       "      <td>20231310152</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>伍际硕</td>\n",
       "      <td>20231310151</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>文涛</td>\n",
       "      <td>20231310150</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>胡星婷</td>\n",
       "      <td>20231310149</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>向志诚</td>\n",
       "      <td>20231310148</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>翁赵熠</td>\n",
       "      <td>20231310147</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>林楠</td>\n",
       "      <td>20231310146</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>朱德伟</td>\n",
       "      <td>20231310145</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>唐塬智</td>\n",
       "      <td>20231310144</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>陈治燃</td>\n",
       "      <td>20231310143</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>11/11</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>刘硕</td>\n",
       "      <td>20231310142</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>4/11</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>马均宇</td>\n",
       "      <td>20231310141</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>吴岩</td>\n",
       "      <td>20231310140</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>马海悦</td>\n",
       "      <td>20231310138</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>陈烨坤</td>\n",
       "      <td>20231310137</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>赵静怡</td>\n",
       "      <td>20231310136</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>余姗珊</td>\n",
       "      <td>20231310135</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>侯绍平</td>\n",
       "      <td>20231310134</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>罗瀛</td>\n",
       "      <td>20231310133</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>陈皓晗</td>\n",
       "      <td>20231310132</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>朱淇蔓</td>\n",
       "      <td>20231310131</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>吴俊鎔</td>\n",
       "      <td>20231310130</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>王庆南</td>\n",
       "      <td>20231310129</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>傅英姿</td>\n",
       "      <td>20231310128</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>林坤宇</td>\n",
       "      <td>20231310127</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>林凯怡</td>\n",
       "      <td>20231310125</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>陈梦雪</td>\n",
       "      <td>20231310124</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>张润泽</td>\n",
       "      <td>20231310123</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>李凌翔</td>\n",
       "      <td>20231310122</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>庄杰雄</td>\n",
       "      <td>20231310121</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>林欣</td>\n",
       "      <td>20231310120</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>倪旭昶</td>\n",
       "      <td>20231310119</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>林琦凤</td>\n",
       "      <td>20231310118</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>陈佳伟</td>\n",
       "      <td>20231310117</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>陈龙</td>\n",
       "      <td>20231310116</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>李冬怡</td>\n",
       "      <td>20231310115</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>林佳怡</td>\n",
       "      <td>20231310114</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>姚鸿斌</td>\n",
       "      <td>20231310113</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>徐伟涛</td>\n",
       "      <td>20231310112</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>林志杰</td>\n",
       "      <td>20231310111</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>葛榛</td>\n",
       "      <td>20231310110</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>施广旭</td>\n",
       "      <td>20231310109</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9/11</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>陆湘雄</td>\n",
       "      <td>20231310108</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>卢述桔</td>\n",
       "      <td>20231310107</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>张鹏泉</td>\n",
       "      <td>20231310106</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>陈嘉诚</td>\n",
       "      <td>20231310105</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>金婉欣</td>\n",
       "      <td>20231310104</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>叶亦坤</td>\n",
       "      <td>20231310103</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>郑佳荣</td>\n",
       "      <td>20231310102</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310101</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>苏梓珊</td>\n",
       "      <td>20221310220</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8/11</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>刘宸言</td>\n",
       "      <td>20221310205</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>10/11</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>朱文清</td>\n",
       "      <td>2018126105</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   学生姓名        学号/工号   院系     专业      班级    提交数   被批阅  最高分  最低分  平均分(计算已批阅)\n",
       "0   林福滨  20231310154  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "1    周昊  20231310153  工学院  大数据技术  数据2311   6/11   0/6    0    0           0\n",
       "2   曹梓扬  20231310152  工学院  大数据技术  数据2311   5/11   0/5    0    0           0\n",
       "3   伍际硕  20231310151  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "4    文涛  20231310150  工学院  大数据技术  数据2311   5/11   0/5    0    0           0\n",
       "5   胡星婷  20231310149  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "6   向志诚  20231310148  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "7   翁赵熠  20231310147  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "8    林楠  20231310146  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "9   朱德伟  20231310145  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "10  唐塬智  20231310144  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "11  陈治燃  20231310143  工学院  大数据技术  数据2311  11/11  0/11    0    0           0\n",
       "12   刘硕  20231310142  工学院  大数据技术  数据2311   4/11   0/4    0    0           0\n",
       "13  马均宇  20231310141  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "14   吴岩  20231310140  工学院  大数据技术  数据2311   9/11   0/9    0    0           0\n",
       "15  马海悦  20231310138  工学院  大数据技术  数据2311   9/11   0/9    0    0           0\n",
       "16  陈烨坤  20231310137  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "17  赵静怡  20231310136  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "18  余姗珊  20231310135  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "19  侯绍平  20231310134  工学院  大数据技术  数据2311   6/11   0/6    0    0           0\n",
       "20   罗瀛  20231310133  工学院  大数据技术  数据2311   8/11   0/8    0    0           0\n",
       "21  陈皓晗  20231310132  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "22  朱淇蔓  20231310131  工学院  大数据技术  数据2311   0/11   0/0    0    0           0\n",
       "23  吴俊鎔  20231310130  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "24  王庆南  20231310129  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "25  傅英姿  20231310128  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "26  林坤宇  20231310127  工学院  大数据技术  数据2311   8/11   0/8    0    0           0\n",
       "27  林凯怡  20231310125  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "28  陈梦雪  20231310124  工学院  大数据技术  数据2311   5/11   0/5    0    0           0\n",
       "29  张润泽  20231310123  工学院  大数据技术  数据2311   9/11   0/9    0    0           0\n",
       "30  李凌翔  20231310122  工学院  大数据技术  数据2311   6/11   0/6    0    0           0\n",
       "31  庄杰雄  20231310121  工学院  大数据技术  数据2311   8/11   0/8    0    0           0\n",
       "32   林欣  20231310120  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "33  倪旭昶  20231310119  工学院  大数据技术  数据2311   9/11   0/9    0    0           0\n",
       "34  林琦凤  20231310118  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "35  陈佳伟  20231310117  工学院  大数据技术  数据2311   6/11   0/6    0    0           0\n",
       "36   陈龙  20231310116  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "37  李冬怡  20231310115  工学院  大数据技术  数据2311   9/11   0/9    0    0           0\n",
       "38  林佳怡  20231310114  工学院  大数据技术  数据2311   8/11   0/8    0    0           0\n",
       "39  姚鸿斌  20231310113  工学院  大数据技术  数据2311   6/11   0/6    0    0           0\n",
       "40  徐伟涛  20231310112  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "41  林志杰  20231310111  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "42   葛榛  20231310110  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "43  施广旭  20231310109  工学院  大数据技术  数据2311   9/11   0/9    0    0           0\n",
       "44  陆湘雄  20231310108  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "45  卢述桔  20231310107  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "46  张鹏泉  20231310106  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "47  陈嘉诚  20231310105  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "48  金婉欣  20231310104  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "49  叶亦坤  20231310103  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "50  郑佳荣  20231310102  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "51   陈昊  20231310101  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "52  苏梓珊  20221310220  工学院  大数据技术  数据2311   8/11   0/8    0    0           0\n",
       "53  刘宸言  20221310205  工学院  大数据技术  数据2311  10/11  0/10    0    0           0\n",
       "54  朱文清   2018126105  工学院  大数据技术  数据2311   5/11   0/5    0    0           0"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy2311 = pd.read_excel('数据2311学生完成统计.xlsx' ,skiprows = 2)\n",
    "zy2311"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "D:\\study\\anaconda\\Lib\\site-packages\\openpyxl\\styles\\stylesheet.py:237: UserWarning: Workbook contains no default style, apply openpyxl's default\n",
      "  warn(\"Workbook contains no default style, apply openpyxl's default\")\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>院系</th>\n",
       "      <th>专业</th>\n",
       "      <th>班级</th>\n",
       "      <th>提交数</th>\n",
       "      <th>被批阅</th>\n",
       "      <th>最高分</th>\n",
       "      <th>最低分</th>\n",
       "      <th>平均分(计算已批阅)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>陈欣蕾</td>\n",
       "      <td>20231790208</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310251</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>贾兆</td>\n",
       "      <td>20231310250</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>林敬耀</td>\n",
       "      <td>20231310249</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>钟雨渲</td>\n",
       "      <td>20231310248</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>饶煌彪</td>\n",
       "      <td>20231310247</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>黄朱晴</td>\n",
       "      <td>20231310246</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>郭佳琪</td>\n",
       "      <td>20231310245</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11/14</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>肖艳妮</td>\n",
       "      <td>20231310244</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>14/14</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>陈国洪</td>\n",
       "      <td>20231310243</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>陈渝儿</td>\n",
       "      <td>20231310242</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>王伟凡</td>\n",
       "      <td>20231310241</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>陈慧真</td>\n",
       "      <td>20231310240</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>曹俊豪</td>\n",
       "      <td>20231310239</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>陈灿贤</td>\n",
       "      <td>20231310237</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>陈隆嘉</td>\n",
       "      <td>20231310236</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>颜悦婷</td>\n",
       "      <td>20231310235</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>鲁家灿</td>\n",
       "      <td>20231310234</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>钱孟杰</td>\n",
       "      <td>20231310233</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>郭可怡</td>\n",
       "      <td>20231310232</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>车炯</td>\n",
       "      <td>20231310231</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>林元曦</td>\n",
       "      <td>20231310230</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4/14</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>王炉垚</td>\n",
       "      <td>20231310229</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4/14</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>张斌彬</td>\n",
       "      <td>20231310227</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>陈瑞枫</td>\n",
       "      <td>20231310226</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>王标凌</td>\n",
       "      <td>20231310225</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>11/14</td>\n",
       "      <td>0/11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>任志洋</td>\n",
       "      <td>20231310224</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>张志鹏</td>\n",
       "      <td>20231310223</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4/14</td>\n",
       "      <td>0/4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>林传江</td>\n",
       "      <td>20231310222</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>2/14</td>\n",
       "      <td>0/2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>詹方煜</td>\n",
       "      <td>20231310221</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>翁诚峰</td>\n",
       "      <td>20231310220</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>吴思钰</td>\n",
       "      <td>20231310219</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>李家烨</td>\n",
       "      <td>20231310218</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>林涛</td>\n",
       "      <td>20231310217</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0/14</td>\n",
       "      <td>0/0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>苏源城</td>\n",
       "      <td>20231310216</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>陈佳阳</td>\n",
       "      <td>20231310215</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>王正元</td>\n",
       "      <td>20231310214</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>吴丽媛</td>\n",
       "      <td>20231310213</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>林金</td>\n",
       "      <td>20231310212</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10/14</td>\n",
       "      <td>0/10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>钟淑川</td>\n",
       "      <td>20231310211</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5/14</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>黄锦弘</td>\n",
       "      <td>20231310210</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>苏增宏</td>\n",
       "      <td>20231310209</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>叶有鑫</td>\n",
       "      <td>20231310208</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>叶育贤</td>\n",
       "      <td>20231310207</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8/14</td>\n",
       "      <td>0/8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>陈双俊</td>\n",
       "      <td>20231310206</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>吴泰成</td>\n",
       "      <td>20231310205</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>卢作培</td>\n",
       "      <td>20231310204</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>邱粤汉</td>\n",
       "      <td>20231310203</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5/14</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>许仕凡</td>\n",
       "      <td>20231310202</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1/14</td>\n",
       "      <td>0/1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>傅景华</td>\n",
       "      <td>20231310201</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>高存平</td>\n",
       "      <td>20221310228</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   学生姓名        学号/工号   院系     专业      班级    提交数   被批阅  最高分  最低分  平均分(计算已批阅)\n",
       "0   陈欣蕾  20231790208  工学院  大数据技术  数据2312   0/14   0/0    0    0           0\n",
       "1    陈昊  20231310251  工学院  大数据技术  数据2312   0/14   0/0    0    0           0\n",
       "2    贾兆  20231310250  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "3   林敬耀  20231310249  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "4   钟雨渲  20231310248  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "5   饶煌彪  20231310247  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "6   黄朱晴  20231310246  工学院  大数据技术  数据2312   8/14   0/8    0    0           0\n",
       "7   郭佳琪  20231310245  工学院  大数据技术  数据2312  11/14  0/11    0    0           0\n",
       "8   肖艳妮  20231310244  工学院  大数据技术  数据2312  14/14  0/14    0    0           0\n",
       "9   陈国洪  20231310243  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "10  陈渝儿  20231310242  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "11  王伟凡  20231310241  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "12  陈慧真  20231310240  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "13  曹俊豪  20231310239  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "14  陈灿贤  20231310237  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "15  陈隆嘉  20231310236  工学院  大数据技术  数据2312   0/14   0/0    0    0           0\n",
       "16  颜悦婷  20231310235  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "17  鲁家灿  20231310234  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "18  钱孟杰  20231310233  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "19  郭可怡  20231310232  工学院  大数据技术  数据2312  12/14  0/12    0    0           0\n",
       "20   车炯  20231310231  工学院  大数据技术  数据2312   0/14   0/0    0    0           0\n",
       "21  林元曦  20231310230  工学院  大数据技术  数据2312   4/14   0/4    0    0           0\n",
       "22  王炉垚  20231310229  工学院  大数据技术  数据2312   4/14   0/4    0    0           0\n",
       "23  张斌彬  20231310227  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "24  陈瑞枫  20231310226  工学院  大数据技术  数据2312   8/14   0/8    0    0           0\n",
       "25  王标凌  20231310225  工学院  大数据技术  数据2312  11/14  0/11    0    0           0\n",
       "26  任志洋  20231310224  工学院  大数据技术  数据2312   8/14   0/8    0    0           0\n",
       "27  张志鹏  20231310223  工学院  大数据技术  数据2312   4/14   0/4    0    0           0\n",
       "28  林传江  20231310222  工学院  大数据技术  数据2312   2/14   0/2    0    0           0\n",
       "29  詹方煜  20231310221  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "30  翁诚峰  20231310220  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "31  吴思钰  20231310219  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "32  李家烨  20231310218  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "33   林涛  20231310217  工学院  大数据技术  数据2312   0/14   0/0    0    0           0\n",
       "34  苏源城  20231310216  工学院  大数据技术  数据2312  12/14  0/12    0    0           0\n",
       "35  陈佳阳  20231310215  工学院  大数据技术  数据2312  12/14  0/12    0    0           0\n",
       "36  王正元  20231310214  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "37  吴丽媛  20231310213  工学院  大数据技术  数据2312   8/14   0/8    0    0           0\n",
       "38   林金  20231310212  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
       "39  钟淑川  20231310211  工学院  大数据技术  数据2312   5/14   0/5    0    0           0\n",
       "40  黄锦弘  20231310210  工学院  大数据技术  数据2312  12/14  0/12    0    0           0\n",
       "41  苏增宏  20231310209  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "42  叶有鑫  20231310208  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "43  叶育贤  20231310207  工学院  大数据技术  数据2312   8/14   0/8    0    0           0\n",
       "44  陈双俊  20231310206  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "45  吴泰成  20231310205  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "46  卢作培  20231310204  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "47  邱粤汉  20231310203  工学院  大数据技术  数据2312   5/14   0/5    0    0           0\n",
       "48  许仕凡  20231310202  工学院  大数据技术  数据2312   1/14   0/1    0    0           0\n",
       "49  傅景华  20231310201  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "50  高存平  20221310228  工学院  大数据技术  数据2312  12/14  0/12    0    0           0"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy2312 = pd.read_excel('数据2312学生完成统计.xlsx',skiprows = 2)\n",
    "zy2312"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1.2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    姓名        学号/工号          学校   院系     专业    行政班级  出勤（次）  缺勤（次）  已过期（次）  \\\n",
      "0  朱文清   2018126105  厦门兴才职业技术学院  工学院  大数据技术  数据2311     11      3       0   \n",
      "1  刘宸言  20221310205  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
      "2  苏梓珊  20221310220  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      2       0   \n",
      "3   陈昊  20231310101  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
      "4  郑佳荣  20231310102  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
      "\n",
      "   早退（次）  迟到（次）  病假（次）  事假（次）  公假（次）  签到率(%)  \n",
      "0      0      0      0      0      0   78.57  \n",
      "1      0      0      0      0      0   92.86  \n",
      "2      0      0      0      0      0   85.71  \n",
      "3      0      0      0      0      0  100.00  \n",
      "4      0      0      0      0      0  100.00  \n"
     ]
    }
   ],
   "source": [
    "print(qd2311.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    姓名        学号/工号          学校   院系     专业    行政班级  出勤（次）  缺勤（次）  已过期（次）  \\\n",
      "0  高存平  20221310228  厦门兴才职业技术学院  工学院  大数据技术  数据2312     10      5       0   \n",
      "1  傅景华  20231310201  厦门兴才职业技术学院  工学院  大数据技术  数据2312     12      2       0   \n",
      "2  许仕凡  20231310202  厦门兴才职业技术学院  工学院  大数据技术  数据2312      1     12       0   \n",
      "3  邱粤汉  20231310203  厦门兴才职业技术学院  工学院  大数据技术  数据2312      8      6       0   \n",
      "4  卢作培  20231310204  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
      "\n",
      "   早退（次）  迟到（次）  病假（次）  事假（次）  公假（次）  签到率(%)  \n",
      "0      0      0      0      0      0   66.67  \n",
      "1      0      1      0      0      0   80.00  \n",
      "2      0      1      0      1      0    6.67  \n",
      "3      0      1      0      0      0   53.33  \n",
      "4      0      0      0      0      0  100.00  \n"
     ]
    }
   ],
   "source": [
    "print(qd2312.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  学生姓名        学号/工号   院系     专业      班级   提交数  被批阅  最高分  最低分  平均分(计算已批阅)\n",
      "0  林福滨  20231310154  工学院  大数据技术  数据2311  7/11  0/7    0    0           0\n",
      "1   周昊  20231310153  工学院  大数据技术  数据2311  6/11  0/6    0    0           0\n",
      "2  曹梓扬  20231310152  工学院  大数据技术  数据2311  5/11  0/5    0    0           0\n",
      "3  伍际硕  20231310151  工学院  大数据技术  数据2311  7/11  0/7    0    0           0\n",
      "4   文涛  20231310150  工学院  大数据技术  数据2311  5/11  0/5    0    0           0\n"
     ]
    }
   ],
   "source": [
    "print(zy2311.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  学生姓名        学号/工号   院系     专业      班级    提交数   被批阅  最高分  最低分  平均分(计算已批阅)\n",
      "0  陈欣蕾  20231790208  工学院  大数据技术  数据2312   0/14   0/0    0    0           0\n",
      "1   陈昊  20231310251  工学院  大数据技术  数据2312   0/14   0/0    0    0           0\n",
      "2   贾兆  20231310250  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n",
      "3  林敬耀  20231310249  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
      "4  钟雨渲  20231310248  工学院  大数据技术  数据2312  10/14  0/10    0    0           0\n"
     ]
    }
   ],
   "source": [
    "print(zy2312.head())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 第二题（数据合并）"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2.1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>学校</th>\n",
       "      <th>院系</th>\n",
       "      <th>专业</th>\n",
       "      <th>行政班级</th>\n",
       "      <th>出勤（次）</th>\n",
       "      <th>缺勤（次）</th>\n",
       "      <th>已过期（次）</th>\n",
       "      <th>早退（次）</th>\n",
       "      <th>迟到（次）</th>\n",
       "      <th>病假（次）</th>\n",
       "      <th>事假（次）</th>\n",
       "      <th>公假（次）</th>\n",
       "      <th>签到率(%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>朱文清</td>\n",
       "      <td>2018126105</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>78.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>刘宸言</td>\n",
       "      <td>20221310205</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>苏梓珊</td>\n",
       "      <td>20221310220</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310101</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>郑佳荣</td>\n",
       "      <td>20231310102</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>钟雨渲</td>\n",
       "      <td>20231310248</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>林敬耀</td>\n",
       "      <td>20231310249</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>贾兆</td>\n",
       "      <td>20231310250</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>46.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310251</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>陈欣蕾</td>\n",
       "      <td>20231790208</td>\n",
       "      <td>厦门兴才职业技术学院</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     姓名        学号/工号          学校   院系     专业    行政班级  出勤（次）  缺勤（次）  已过期（次）  \\\n",
       "0   朱文清   2018126105  厦门兴才职业技术学院  工学院  大数据技术  数据2311     11      3       0   \n",
       "1   刘宸言  20221310205  厦门兴才职业技术学院  工学院  大数据技术  数据2311     13      1       0   \n",
       "2   苏梓珊  20221310220  厦门兴才职业技术学院  工学院  大数据技术  数据2311     12      2       0   \n",
       "3    陈昊  20231310101  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "4   郑佳荣  20231310102  厦门兴才职业技术学院  工学院  大数据技术  数据2311     14      0       0   \n",
       "..  ...          ...         ...  ...    ...     ...    ...    ...     ...   \n",
       "46  钟雨渲  20231310248  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "47  林敬耀  20231310249  厦门兴才职业技术学院  工学院  大数据技术  数据2312     15      0       0   \n",
       "48   贾兆  20231310250  厦门兴才职业技术学院  工学院  大数据技术  数据2312      7      5       0   \n",
       "49   陈昊  20231310251  厦门兴才职业技术学院  工学院  大数据技术  数据2312      1     11       0   \n",
       "50  陈欣蕾  20231790208  厦门兴才职业技术学院  工学院  大数据技术  数据2312      1     14       0   \n",
       "\n",
       "    早退（次）  迟到（次）  病假（次）  事假（次）  公假（次）  签到率(%)  \n",
       "0       0      0      0      0      0   78.57  \n",
       "1       0      0      0      0      0   92.86  \n",
       "2       0      0      0      0      0   85.71  \n",
       "3       0      0      0      0      0  100.00  \n",
       "4       0      0      0      0      0  100.00  \n",
       "..    ...    ...    ...    ...    ...     ...  \n",
       "46      0      0      0      0      0  100.00  \n",
       "47      0      0      0      0      0  100.00  \n",
       "48      0      2      0      1      0   46.67  \n",
       "49      0      2      0      1      0    6.67  \n",
       "50      0      0      0      0      0    6.67  \n",
       "\n",
       "[106 rows x 15 columns]"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "qd = pd.concat([qd2311,qd2312])\n",
    "qd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2.2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>院系</th>\n",
       "      <th>专业</th>\n",
       "      <th>班级</th>\n",
       "      <th>提交数</th>\n",
       "      <th>被批阅</th>\n",
       "      <th>最高分</th>\n",
       "      <th>最低分</th>\n",
       "      <th>平均分(计算已批阅)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>林福滨</td>\n",
       "      <td>20231310154</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>周昊</td>\n",
       "      <td>20231310153</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>曹梓扬</td>\n",
       "      <td>20231310152</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>伍际硕</td>\n",
       "      <td>20231310151</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>文涛</td>\n",
       "      <td>20231310150</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>卢作培</td>\n",
       "      <td>20231310204</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>邱粤汉</td>\n",
       "      <td>20231310203</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5/14</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>许仕凡</td>\n",
       "      <td>20231310202</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1/14</td>\n",
       "      <td>0/1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>傅景华</td>\n",
       "      <td>20231310201</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>高存平</td>\n",
       "      <td>20221310228</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   学生姓名        学号/工号   院系     专业      班级    提交数   被批阅  最高分  最低分  平均分(计算已批阅)\n",
       "0   林福滨  20231310154  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "1    周昊  20231310153  工学院  大数据技术  数据2311   6/11   0/6    0    0           0\n",
       "2   曹梓扬  20231310152  工学院  大数据技术  数据2311   5/11   0/5    0    0           0\n",
       "3   伍际硕  20231310151  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "4    文涛  20231310150  工学院  大数据技术  数据2311   5/11   0/5    0    0           0\n",
       "..  ...          ...  ...    ...     ...    ...   ...  ...  ...         ...\n",
       "46  卢作培  20231310204  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "47  邱粤汉  20231310203  工学院  大数据技术  数据2312   5/14   0/5    0    0           0\n",
       "48  许仕凡  20231310202  工学院  大数据技术  数据2312   1/14   0/1    0    0           0\n",
       "49  傅景华  20231310201  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "50  高存平  20221310228  工学院  大数据技术  数据2312  12/14  0/12    0    0           0\n",
       "\n",
       "[106 rows x 10 columns]"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy = pd.concat([zy2311,zy2312])\n",
    "zy"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 第三题 考勤表数据处理"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3.1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>行政班级</th>\n",
       "      <th>出勤（次）</th>\n",
       "      <th>缺勤（次）</th>\n",
       "      <th>已过期（次）</th>\n",
       "      <th>早退（次）</th>\n",
       "      <th>迟到（次）</th>\n",
       "      <th>病假（次）</th>\n",
       "      <th>事假（次）</th>\n",
       "      <th>公假（次）</th>\n",
       "      <th>签到率(%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>朱文清</td>\n",
       "      <td>2018126105</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>78.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>刘宸言</td>\n",
       "      <td>20221310205</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>苏梓珊</td>\n",
       "      <td>20221310220</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310101</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>郑佳荣</td>\n",
       "      <td>20231310102</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    姓名        学号/工号    行政班级  出勤（次）  缺勤（次）  已过期（次）  早退（次）  迟到（次）  病假（次）  事假（次）  \\\n",
       "0  朱文清   2018126105  数据2311     11      3       0      0      0      0      0   \n",
       "1  刘宸言  20221310205  数据2311     13      1       0      0      0      0      0   \n",
       "2  苏梓珊  20221310220  数据2311     12      2       0      0      0      0      0   \n",
       "3   陈昊  20231310101  数据2311     14      0       0      0      0      0      0   \n",
       "4  郑佳荣  20231310102  数据2311     14      0       0      0      0      0      0   \n",
       "\n",
       "   公假（次）  签到率(%)  \n",
       "0      0   78.57  \n",
       "1      0   92.86  \n",
       "2      0   85.71  \n",
       "3      0  100.00  \n",
       "4      0  100.00  "
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b = ['学校', '院系', '专业']\n",
    "df = qd.drop(columns=b)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3.2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['出勤次数'] = df['迟到（次）'] + df['病假（次）']+ df['事假（次）'] + df['公假（次）'] \n",
    "df['出勤率'] = df['出勤次数']/df['出勤次数'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     0\n",
       "1     0\n",
       "2     0\n",
       "3     0\n",
       "4     0\n",
       "     ..\n",
       "46    0\n",
       "47    0\n",
       "48    3\n",
       "49    3\n",
       "50    0\n",
       "Name: 出勤次数, Length: 106, dtype: int64"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['出勤次数']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3.3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      58\n",
       "1      86\n",
       "2      72\n",
       "3     100\n",
       "4     100\n",
       "     ... \n",
       "46    100\n",
       "47    100\n",
       "48     12\n",
       "49    -72\n",
       "50    -96\n",
       "Name: 考勤分数, Length: 106, dtype: int64"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['考勤分数'] = 100 - (df['缺勤（次）']*14 + df['迟到（次）']*5 + df['事假（次）']*8)\n",
    "df['考勤分数']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3.4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>行政班级</th>\n",
       "      <th>出勤（次）</th>\n",
       "      <th>缺勤（次）</th>\n",
       "      <th>已过期（次）</th>\n",
       "      <th>早退（次）</th>\n",
       "      <th>迟到（次）</th>\n",
       "      <th>病假（次）</th>\n",
       "      <th>事假（次）</th>\n",
       "      <th>公假（次）</th>\n",
       "      <th>签到率(%)</th>\n",
       "      <th>考勤分数</th>\n",
       "      <th>出勤次数</th>\n",
       "      <th>出勤率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>朱文清</td>\n",
       "      <td>2018126105</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>78.57</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>刘宸言</td>\n",
       "      <td>20221310205</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92.86</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>苏梓珊</td>\n",
       "      <td>20221310220</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.71</td>\n",
       "      <td>72</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310101</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>郑佳荣</td>\n",
       "      <td>20231310102</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>钟雨渲</td>\n",
       "      <td>20231310248</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>林敬耀</td>\n",
       "      <td>20231310249</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>贾兆</td>\n",
       "      <td>20231310250</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>46.67</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>0.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310251</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-72</td>\n",
       "      <td>3</td>\n",
       "      <td>0.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>陈欣蕾</td>\n",
       "      <td>20231790208</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-96</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     姓名        学号/工号    行政班级  出勤（次）  缺勤（次）  已过期（次）  早退（次）  迟到（次）  病假（次）  \\\n",
       "0   朱文清   2018126105  数据2311     11      3       0      0      0      0   \n",
       "1   刘宸言  20221310205  数据2311     13      1       0      0      0      0   \n",
       "2   苏梓珊  20221310220  数据2311     12      2       0      0      0      0   \n",
       "3    陈昊  20231310101  数据2311     14      0       0      0      0      0   \n",
       "4   郑佳荣  20231310102  数据2311     14      0       0      0      0      0   \n",
       "..  ...          ...     ...    ...    ...     ...    ...    ...    ...   \n",
       "46  钟雨渲  20231310248  数据2312     15      0       0      0      0      0   \n",
       "47  林敬耀  20231310249  数据2312     15      0       0      0      0      0   \n",
       "48   贾兆  20231310250  数据2312      7      5       0      0      2      0   \n",
       "49   陈昊  20231310251  数据2312      1     11       0      0      2      0   \n",
       "50  陈欣蕾  20231790208  数据2312      1     14       0      0      0      0   \n",
       "\n",
       "    事假（次）  公假（次）  签到率(%)  考勤分数  出勤次数       出勤率  \n",
       "0       0      0   78.57    58     0  0.000000  \n",
       "1       0      0   92.86    86     0  0.000000  \n",
       "2       0      0   85.71    72     0  0.000000  \n",
       "3       0      0  100.00   100     0  0.000000  \n",
       "4       0      0  100.00   100     0  0.000000  \n",
       "..    ...    ...     ...   ...   ...       ...  \n",
       "46      0      0  100.00   100     0  0.000000  \n",
       "47      0      0  100.00   100     0  0.000000  \n",
       "48      1      0   46.67    12     3  0.428571  \n",
       "49      1      0    6.67   -72     3  0.428571  \n",
       "50      0      0    6.67   -96     0  0.000000  \n",
       "\n",
       "[106 rows x 15 columns]"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3.5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>行政班级</th>\n",
       "      <th>出勤（次）</th>\n",
       "      <th>缺勤（次）</th>\n",
       "      <th>已过期（次）</th>\n",
       "      <th>早退（次）</th>\n",
       "      <th>迟到（次）</th>\n",
       "      <th>病假（次）</th>\n",
       "      <th>事假（次）</th>\n",
       "      <th>公假（次）</th>\n",
       "      <th>签到率(%)</th>\n",
       "      <th>考勤分数</th>\n",
       "      <th>出勤次数</th>\n",
       "      <th>出勤率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>林涛</td>\n",
       "      <td>20231310217</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-110</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>陈欣蕾</td>\n",
       "      <td>20231790208</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-96</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>许仕凡</td>\n",
       "      <td>20231310202</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-81</td>\n",
       "      <td>2</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>陈隆嘉</td>\n",
       "      <td>20231310236</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-78</td>\n",
       "      <td>2</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310251</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-72</td>\n",
       "      <td>3</td>\n",
       "      <td>0.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>傅英姿</td>\n",
       "      <td>20231310128</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>85.71</td>\n",
       "      <td>100</td>\n",
       "      <td>2</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>詹方煜</td>\n",
       "      <td>20231310221</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>张鹏泉</td>\n",
       "      <td>20231310106</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>林欣</td>\n",
       "      <td>20231310120</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>施广旭</td>\n",
       "      <td>20231310109</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>100</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     姓名        学号/工号    行政班级  出勤（次）  缺勤（次）  已过期（次）  早退（次）  迟到（次）  病假（次）  \\\n",
       "17   林涛  20231310217  数据2312      0     15       0      0      0      0   \n",
       "50  陈欣蕾  20231790208  数据2312      1     14       0      0      0      0   \n",
       "2   许仕凡  20231310202  数据2312      1     12       0      0      1      0   \n",
       "35  陈隆嘉  20231310236  数据2312      1     12       0      0      2      0   \n",
       "49   陈昊  20231310251  数据2312      1     11       0      0      2      0   \n",
       "..  ...          ...     ...    ...    ...     ...    ...    ...    ...   \n",
       "29  傅英姿  20231310128  数据2311     12      0       0      0      0      0   \n",
       "21  詹方煜  20231310221  数据2312     15      0       0      0      0      0   \n",
       "8   张鹏泉  20231310106  数据2311     14      0       0      0      0      0   \n",
       "22   林欣  20231310120  数据2311     14      0       0      0      0      0   \n",
       "11  施广旭  20231310109  数据2311     14      0       0      0      0      0   \n",
       "\n",
       "    事假（次）  公假（次）  签到率(%)  考勤分数  出勤次数       出勤率  \n",
       "17      0      0    0.00  -110     0  0.000000  \n",
       "50      0      0    6.67   -96     0  0.000000  \n",
       "2       1      0    6.67   -81     2  0.285714  \n",
       "35      0      0    6.67   -78     2  0.285714  \n",
       "49      1      0    6.67   -72     3  0.428571  \n",
       "..    ...    ...     ...   ...   ...       ...  \n",
       "29      0      2   85.71   100     2  0.285714  \n",
       "21      0      0  100.00   100     0  0.000000  \n",
       "8       0      0  100.00   100     0  0.000000  \n",
       "22      0      0  100.00   100     0  0.000000  \n",
       "11      0      0  100.00   100     0  0.000000  \n",
       "\n",
       "[106 rows x 15 columns]"
      ]
     },
     "execution_count": 168,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "qd_sorted = df.sort_values(by='考勤分数')\n",
    "qd_sorted"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>行政班级</th>\n",
       "      <th>出勤（次）</th>\n",
       "      <th>缺勤（次）</th>\n",
       "      <th>已过期（次）</th>\n",
       "      <th>早退（次）</th>\n",
       "      <th>迟到（次）</th>\n",
       "      <th>病假（次）</th>\n",
       "      <th>事假（次）</th>\n",
       "      <th>公假（次）</th>\n",
       "      <th>签到率(%)</th>\n",
       "      <th>考勤分数</th>\n",
       "      <th>出勤次数</th>\n",
       "      <th>出勤率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>林涛</td>\n",
       "      <td>20231310217</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-110</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>陈欣蕾</td>\n",
       "      <td>20231790208</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-96</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>许仕凡</td>\n",
       "      <td>20231310202</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-81</td>\n",
       "      <td>2</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>陈隆嘉</td>\n",
       "      <td>20231310236</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-78</td>\n",
       "      <td>2</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>陈昊</td>\n",
       "      <td>20231310251</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6.67</td>\n",
       "      <td>-72</td>\n",
       "      <td>3</td>\n",
       "      <td>0.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>车炯</td>\n",
       "      <td>20231310231</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20.00</td>\n",
       "      <td>-62</td>\n",
       "      <td>1</td>\n",
       "      <td>0.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>林传江</td>\n",
       "      <td>20231310222</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13.33</td>\n",
       "      <td>-55</td>\n",
       "      <td>3</td>\n",
       "      <td>0.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>王炉垚</td>\n",
       "      <td>20231310229</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26.67</td>\n",
       "      <td>-18</td>\n",
       "      <td>4</td>\n",
       "      <td>0.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>陈梦雪</td>\n",
       "      <td>20231310124</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42.86</td>\n",
       "      <td>-12</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>张志鹏</td>\n",
       "      <td>20231310223</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>邱粤汉</td>\n",
       "      <td>20231310203</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53.33</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>贾兆</td>\n",
       "      <td>20231310250</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>46.67</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>0.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>朱淇蔓</td>\n",
       "      <td>20231310131</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>50.00</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>陈佳伟</td>\n",
       "      <td>20231310117</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>57.14</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>林金</td>\n",
       "      <td>20231310212</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33.33</td>\n",
       "      <td>23</td>\n",
       "      <td>7</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>任志洋</td>\n",
       "      <td>20231310224</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>46.67</td>\n",
       "      <td>24</td>\n",
       "      <td>4</td>\n",
       "      <td>0.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>陈龙</td>\n",
       "      <td>20231310116</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64.29</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>庄杰雄</td>\n",
       "      <td>20231310121</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64.29</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>高存平</td>\n",
       "      <td>20221310228</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66.67</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>陈瑞枫</td>\n",
       "      <td>20231310226</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>37</td>\n",
       "      <td>7</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     姓名        学号/工号    行政班级  出勤（次）  缺勤（次）  已过期（次）  早退（次）  迟到（次）  病假（次）  \\\n",
       "17   林涛  20231310217  数据2312      0     15       0      0      0      0   \n",
       "50  陈欣蕾  20231790208  数据2312      1     14       0      0      0      0   \n",
       "2   许仕凡  20231310202  数据2312      1     12       0      0      1      0   \n",
       "35  陈隆嘉  20231310236  数据2312      1     12       0      0      2      0   \n",
       "49   陈昊  20231310251  数据2312      1     11       0      0      2      0   \n",
       "30   车炯  20231310231  数据2312      3     11       0      0      0      0   \n",
       "22  林传江  20231310222  数据2312      2     10       0      0      3      0   \n",
       "28  王炉垚  20231310229  数据2312      4      7       0      0      4      0   \n",
       "26  陈梦雪  20231310124  数据2311      6      8       0      0      0      0   \n",
       "23  张志鹏  20231310223  数据2312      6      6       0      0      3      0   \n",
       "3   邱粤汉  20231310203  数据2312      8      6       0      0      1      0   \n",
       "48   贾兆  20231310250  数据2312      7      5       0      0      2      0   \n",
       "32  朱淇蔓  20231310131  数据2311      7      5       0      0      0      0   \n",
       "19  陈佳伟  20231310117  数据2311      8      6       0      0      0      0   \n",
       "12   林金  20231310212  数据2312      5      3       0      0      7      0   \n",
       "24  任志洋  20231310224  数据2312      7      4       0      0      4      0   \n",
       "18   陈龙  20231310116  数据2311      9      5       0      0      0      0   \n",
       "23  庄杰雄  20231310121  数据2311      9      5       0      0      0      0   \n",
       "0   高存平  20221310228  数据2312     10      5       0      0      0      0   \n",
       "26  陈瑞枫  20231310226  数据2312      6      2       0      0      7      0   \n",
       "\n",
       "    事假（次）  公假（次）  签到率(%)  考勤分数  出勤次数       出勤率  \n",
       "17      0      0    0.00  -110     0  0.000000  \n",
       "50      0      0    6.67   -96     0  0.000000  \n",
       "2       1      0    6.67   -81     2  0.285714  \n",
       "35      0      0    6.67   -78     2  0.285714  \n",
       "49      1      0    6.67   -72     3  0.428571  \n",
       "30      1      0   20.00   -62     1  0.142857  \n",
       "22      0      0   13.33   -55     3  0.428571  \n",
       "28      0      0   26.67   -18     4  0.571429  \n",
       "26      0      0   42.86   -12     0  0.000000  \n",
       "23      0      0   40.00     1     3  0.428571  \n",
       "3       0      0   53.33    11     1  0.142857  \n",
       "48      1      0   46.67    12     3  0.428571  \n",
       "32      2      0   50.00    14     2  0.285714  \n",
       "19      0      0   57.14    16     0  0.000000  \n",
       "12      0      0   33.33    23     7  1.000000  \n",
       "24      0      0   46.67    24     4  0.571429  \n",
       "18      0      0   64.29    30     0  0.000000  \n",
       "23      0      0   64.29    30     0  0.000000  \n",
       "0       0      0   66.67    30     0  0.000000  \n",
       "26      0      0   40.00    37     7  1.000000  "
      ]
     },
     "execution_count": 170,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "qd_sorted.iloc[:20]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3.6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 179,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     姓名        学号/工号    行政班级  出勤（次）  缺勤（次）  已过期（次）  早退（次）  迟到（次）  病假（次）  \\\n",
      "41  陈国洪  20231310243  数据2312     15      0       0      0      0      0   \n",
      "\n",
      "    事假（次）  公假（次）  签到率(%)  考勤分数  出勤次数  出勤率  \n",
      "41      0      0   100.0   100     0  0.0  \n"
     ]
    }
   ],
   "source": [
    "print(df.loc[df['姓名'] == '陈国洪'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 4.作业提交表数据处理"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 4.1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "\"['平均分'] not found in axis\"",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[213], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m zy \u001b[38;5;241m=\u001b[39m zy\u001b[38;5;241m.\u001b[39mdrop(columns\u001b[38;5;241m=\u001b[39m[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m院系\u001b[39m\u001b[38;5;124m'\u001b[39m,\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m专业\u001b[39m\u001b[38;5;124m'\u001b[39m,\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m被批阅\u001b[39m\u001b[38;5;124m'\u001b[39m,\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m最高分\u001b[39m\u001b[38;5;124m'\u001b[39m,\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m最低分\u001b[39m\u001b[38;5;124m'\u001b[39m,\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m平均分\u001b[39m\u001b[38;5;124m'\u001b[39m,\u001b[38;5;124m'\u001b[39m\u001b[38;5;124m平均分(计算已批阅)\u001b[39m\u001b[38;5;124m'\u001b[39m])\n",
      "File \u001b[1;32mD:\\study\\anaconda\\Lib\\site-packages\\pandas\\core\\frame.py:5581\u001b[0m, in \u001b[0;36mDataFrame.drop\u001b[1;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[0;32m   5433\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mdrop\u001b[39m(\n\u001b[0;32m   5434\u001b[0m     \u001b[38;5;28mself\u001b[39m,\n\u001b[0;32m   5435\u001b[0m     labels: IndexLabel \u001b[38;5;241m|\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m   5442\u001b[0m     errors: IgnoreRaise \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mraise\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m   5443\u001b[0m ) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m DataFrame \u001b[38;5;241m|\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[0;32m   5444\u001b[0m \u001b[38;5;250m    \u001b[39m\u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[0;32m   5445\u001b[0m \u001b[38;5;124;03m    Drop specified labels from rows or columns.\u001b[39;00m\n\u001b[0;32m   5446\u001b[0m \n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m   5579\u001b[0m \u001b[38;5;124;03m            weight  1.0     0.8\u001b[39;00m\n\u001b[0;32m   5580\u001b[0m \u001b[38;5;124;03m    \"\"\"\u001b[39;00m\n\u001b[1;32m-> 5581\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28msuper\u001b[39m()\u001b[38;5;241m.\u001b[39mdrop(\n\u001b[0;32m   5582\u001b[0m         labels\u001b[38;5;241m=\u001b[39mlabels,\n\u001b[0;32m   5583\u001b[0m         axis\u001b[38;5;241m=\u001b[39maxis,\n\u001b[0;32m   5584\u001b[0m         index\u001b[38;5;241m=\u001b[39mindex,\n\u001b[0;32m   5585\u001b[0m         columns\u001b[38;5;241m=\u001b[39mcolumns,\n\u001b[0;32m   5586\u001b[0m         level\u001b[38;5;241m=\u001b[39mlevel,\n\u001b[0;32m   5587\u001b[0m         inplace\u001b[38;5;241m=\u001b[39minplace,\n\u001b[0;32m   5588\u001b[0m         errors\u001b[38;5;241m=\u001b[39merrors,\n\u001b[0;32m   5589\u001b[0m     )\n",
      "File \u001b[1;32mD:\\study\\anaconda\\Lib\\site-packages\\pandas\\core\\generic.py:4788\u001b[0m, in \u001b[0;36mNDFrame.drop\u001b[1;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[0;32m   4786\u001b[0m \u001b[38;5;28;01mfor\u001b[39;00m axis, labels \u001b[38;5;129;01min\u001b[39;00m axes\u001b[38;5;241m.\u001b[39mitems():\n\u001b[0;32m   4787\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m labels \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m-> 4788\u001b[0m         obj \u001b[38;5;241m=\u001b[39m obj\u001b[38;5;241m.\u001b[39m_drop_axis(labels, axis, level\u001b[38;5;241m=\u001b[39mlevel, errors\u001b[38;5;241m=\u001b[39merrors)\n\u001b[0;32m   4790\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m inplace:\n\u001b[0;32m   4791\u001b[0m     \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_update_inplace(obj)\n",
      "File \u001b[1;32mD:\\study\\anaconda\\Lib\\site-packages\\pandas\\core\\generic.py:4830\u001b[0m, in \u001b[0;36mNDFrame._drop_axis\u001b[1;34m(self, labels, axis, level, errors, only_slice)\u001b[0m\n\u001b[0;32m   4828\u001b[0m         new_axis \u001b[38;5;241m=\u001b[39m axis\u001b[38;5;241m.\u001b[39mdrop(labels, level\u001b[38;5;241m=\u001b[39mlevel, errors\u001b[38;5;241m=\u001b[39merrors)\n\u001b[0;32m   4829\u001b[0m     \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m-> 4830\u001b[0m         new_axis \u001b[38;5;241m=\u001b[39m axis\u001b[38;5;241m.\u001b[39mdrop(labels, errors\u001b[38;5;241m=\u001b[39merrors)\n\u001b[0;32m   4831\u001b[0m     indexer \u001b[38;5;241m=\u001b[39m axis\u001b[38;5;241m.\u001b[39mget_indexer(new_axis)\n\u001b[0;32m   4833\u001b[0m \u001b[38;5;66;03m# Case for non-unique axis\u001b[39;00m\n\u001b[0;32m   4834\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n",
      "File \u001b[1;32mD:\\study\\anaconda\\Lib\\site-packages\\pandas\\core\\indexes\\base.py:7070\u001b[0m, in \u001b[0;36mIndex.drop\u001b[1;34m(self, labels, errors)\u001b[0m\n\u001b[0;32m   7068\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m mask\u001b[38;5;241m.\u001b[39many():\n\u001b[0;32m   7069\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m errors \u001b[38;5;241m!=\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mignore\u001b[39m\u001b[38;5;124m\"\u001b[39m:\n\u001b[1;32m-> 7070\u001b[0m         \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m(\u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;132;01m{\u001b[39;00mlabels[mask]\u001b[38;5;241m.\u001b[39mtolist()\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m not found in axis\u001b[39m\u001b[38;5;124m\"\u001b[39m)\n\u001b[0;32m   7071\u001b[0m     indexer \u001b[38;5;241m=\u001b[39m indexer[\u001b[38;5;241m~\u001b[39mmask]\n\u001b[0;32m   7072\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mdelete(indexer)\n",
      "\u001b[1;31mKeyError\u001b[0m: \"['平均分'] not found in axis\""
     ]
    }
   ],
   "source": [
    "zy = zy.drop(columns=['院系','专业','被批阅','最高分','最低分','平均分','平均分(计算已批阅)'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 215,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>学生姓名</th>\n",
       "      <th>学号/工号</th>\n",
       "      <th>院系</th>\n",
       "      <th>专业</th>\n",
       "      <th>班级</th>\n",
       "      <th>提交数</th>\n",
       "      <th>被批阅</th>\n",
       "      <th>最高分</th>\n",
       "      <th>最低分</th>\n",
       "      <th>平均分(计算已批阅)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>林福滨</td>\n",
       "      <td>20231310154</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>周昊</td>\n",
       "      <td>20231310153</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>6/11</td>\n",
       "      <td>0/6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>曹梓扬</td>\n",
       "      <td>20231310152</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>伍际硕</td>\n",
       "      <td>20231310151</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>7/11</td>\n",
       "      <td>0/7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>文涛</td>\n",
       "      <td>20231310150</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2311</td>\n",
       "      <td>5/11</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>卢作培</td>\n",
       "      <td>20231310204</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>13/14</td>\n",
       "      <td>0/13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>邱粤汉</td>\n",
       "      <td>20231310203</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>5/14</td>\n",
       "      <td>0/5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>许仕凡</td>\n",
       "      <td>20231310202</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>1/14</td>\n",
       "      <td>0/1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>傅景华</td>\n",
       "      <td>20231310201</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>9/14</td>\n",
       "      <td>0/9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>高存平</td>\n",
       "      <td>20221310228</td>\n",
       "      <td>工学院</td>\n",
       "      <td>大数据技术</td>\n",
       "      <td>数据2312</td>\n",
       "      <td>12/14</td>\n",
       "      <td>0/12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   学生姓名        学号/工号   院系     专业      班级    提交数   被批阅  最高分  最低分  平均分(计算已批阅)\n",
       "0   林福滨  20231310154  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "1    周昊  20231310153  工学院  大数据技术  数据2311   6/11   0/6    0    0           0\n",
       "2   曹梓扬  20231310152  工学院  大数据技术  数据2311   5/11   0/5    0    0           0\n",
       "3   伍际硕  20231310151  工学院  大数据技术  数据2311   7/11   0/7    0    0           0\n",
       "4    文涛  20231310150  工学院  大数据技术  数据2311   5/11   0/5    0    0           0\n",
       "..  ...          ...  ...    ...     ...    ...   ...  ...  ...         ...\n",
       "46  卢作培  20231310204  工学院  大数据技术  数据2312  13/14  0/13    0    0           0\n",
       "47  邱粤汉  20231310203  工学院  大数据技术  数据2312   5/14   0/5    0    0           0\n",
       "48  许仕凡  20231310202  工学院  大数据技术  数据2312   1/14   0/1    0    0           0\n",
       "49  傅景华  20231310201  工学院  大数据技术  数据2312   9/14   0/9    0    0           0\n",
       "50  高存平  20221310228  工学院  大数据技术  数据2312  12/14  0/12    0    0           0\n",
       "\n",
       "[106 rows x 10 columns]"
      ]
     },
     "execution_count": 215,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 4.3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 217,
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (2584861783.py, line 2)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;36m  Cell \u001b[1;32mIn[217], line 2\u001b[1;36m\u001b[0m\n\u001b[1;33m    if 0.8<= zy <=1;\u001b[0m\n\u001b[1;37m                   ^\u001b[0m\n\u001b[1;31mSyntaxError\u001b[0m\u001b[1;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "def zuoye(zy):\n",
    "    if 0.8<= zy <=1;\n",
    "        return '优'\n",
    "    elif 0.7<= zy <0.8;\n",
    "        return '良'\n",
    "    elif 0.333<= zy <0.7;\n",
    "        return '良'\n",
    "    else:\n",
    "        return '取消考试资格';"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 4.4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "zy_sorted = df.sort_values(by='提交率')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 4.5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "zy['作业提交评级'] = zy['提交率'].apply(zuoye)\n",
    "zy"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:base] *",
   "language": "python",
   "name": "conda-base-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
